<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles"%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>公司收费月汇总</title>
<LINK href="images/css.css" type="text/css" rel="stylesheet">
<script language="javascript">
	var req;
	
	function init() {
		if (window.XMLHttpRequest) {
			req = new XMLHttpRequest();
		} else if (window.ActiveXObject) {
			req = new ActiveXObject("Microsoft.XMLHTTP");
		}
	}
	
	//
	function changeDropOfSub() {
		init();
		
		var url="dropChangeAJAX.do?method=changeDropOfSub&distId="+escape(document.forms[0].distId.options[document.forms[0].distId.selectedIndex].value);
		
		req.open("get", url, true);
		req.onreadystatechange = callback;
		req.send(null);
	}
	
	function callback() {
		if (4 == req.readyState) {
			if (200 == req.status) {
				eval(req.responseText);
			}
		}
	}
</script>
</head>

<body>
<table align="center" width="80%" border="0">
	<tr>
		<td class="STYLE4" align="center" bgcolor="#ffffff" colspan="2"
			height="40">公司收费月汇总(${year }年${month }月) 单位:元 
		</td>
	</tr>
	<tr>
		<td>
		<table align="center" class="tableline" cellspacing="1"
			cellpadding="0" width="100%" border="0">
			<tr>
				<td width="10%" align="center" bgcolor="#ffffff">小区</td>
				<td width="10%" align="center" bgcolor="#ffffff">应缴金额</td>
				<td width="10%" align="center" bgcolor="#ffffff">实收金额</td>
				<td width="10%" align="center" bgcolor="#ffffff">物业服务费</td>
				<td width="10%" height="26" align="center" bgcolor="#ffffff">
				电费</td>
				<td width="10%" align="center" bgcolor="#ffffff">水费</td>
				<td width="10%" align="center" bgcolor="#ffffff">停车服务费</td>
				<td width="10%" align="center" bgcolor="#ffffff">垃圾清运费</td>
				<td width="10%" align="center" bgcolor="#ffffff">路灯电费</td>
				<td width="10%" align="center" bgcolor="#ffffff">二次提水电费</td>
			</tr>
			<c:forEach items="${queryList }" var="queryMap">
				<tr>
					<td width="10%" align="center" bgcolor="#ffffff">
					${queryMap.sub.name }</td>
					<td id="one" width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.totalSum }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.paidSum }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.propCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.powerCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.waterCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.carCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.rubbishCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.lightCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.water2ndCharge }" pattern="0.00" />&nbsp;</td>
				</tr>
			</c:forEach>
			<tr>
				<td width="10%" align="center" bgcolor="#ffffff">总计:</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${totalSumRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${paidSumRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${propChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${powerChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${waterChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${carChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${rubbishChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${lightChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${water2ndChargeRet }" pattern="0.00" />&nbsp;</td>
			</tr>
		</table>
		</td>
	</tr>
	<tr>
		<td align="right"><input
				type="button" value="导出Excel报表" style="color: green;"
				onclick="window.location.href='propQuery.do?method=companyMonthlyChargeExcel&year=${year }&month=${month }'">
		</td>
	</tr>
</table>
</body>
</html>